Almost every DBA has had that sinking feeling when you realize that circumstances beyond your control have damaged or caused the loss of data in your database. 几乎所有DBA都有过这样的经历:当意识到一些无法控制的状况已经毁坏或丢失了数据库中的数据时,一定会感到很沮丧。
This gives you up to four kinds of backup data you can use to recover a damaged database 这为恢复受损数据库提供4种类型的备份数据
When you try to repair a backup, make sure to do this with a copy of the damaged database in case your attempts to repair the database fail. 尝试修复备份时,请确保使用已损坏数据库的副本进行修复尝试,以防修复数据库的尝试失败。
There's also something called "emergency mode" which is a "panic" status you can set in order to try to get data out of a damaged database. 这里还同样有叫做“紧急模式(emergencymode)”的东西,它是一个为从严重损坏的数据库中取出数据而可以设置的“恐慌”状态。
When you use back up the tail of the log on a damaged database, some of the metadata ordinarily captured in log backups might be unavailable. 对受损数据库备份日志尾部时,日志备份中正常捕获的部分元数据可能不可用。
All of the redundancy, security and fault tolerance in the world cannot help you when it comes to a damaged, corrupt, or lost database. 当数据库损坏、毁坏或丢失时,世界上任何冗余、安全和容错技术都将无能为力。
Using Log File to Restore the Damaged Database 利用日志文件恢复损坏的数据库
At the last, the paper gives a method for dynamically restoring the damaged database file and table file. 最后给出了动态恢复被破坏的数据库文件及表文件的方法。
Restoration of the Damaged Database 如何恢复被破坏的数据库
This paper presents not only a method to recover data from damaged Oracle database but also details analysis of control file, data file and log file through analyzing logical and physical structure of Oracle database. 通过对Oracle数据库物理结构和逻辑结构的分析,给出了Oracle控制文件、数据文件和日志文件的文件格式,同时给出了一个文件级的Oracle数据库数据恢复方法。
It is firstly definitely pointed out that the identification results of damaged cables are quite potentially unreliable, if the identification just based on increasing the amount of simulation cases and lingual description of the database of the simulation cases. 首次明确指出仅仅依靠增加模拟案例的数量,根据对模拟案例的总结归纳来识别受损索是非常困难的,其结论往往是不可靠的。
Damaged data isolation technology can let the attacked database function in a normal way while prevent the damaged data from spreading. 受损数据隔离技术使数据库遭到破坏时既能对外提供正常的服务,又能防止受损数据的进一步扩散。